create procedure [dbo].[BAEEventSetupAddGroup] @eventCode varchar(15),
     @groupName varchar(10),
     @groupLabel varchar(255) ,
     @grouporder int,
     @groupText varchar(255) as
SELECT * FROM EventSetupGroup
    WHERE EventCode = @eventCode AND GroupName = @groupName
    IF(@@RowCount > 0)
        BEGIN
            UPDATE EventSetupGroup
                SET GroupLabel = @groupLabel, GroupOrder = @grouporder, GroupPageMessage = @groupText
            WHERE EventCode = @eventCode AND GroupName = @groupName
        END
    ELSE
        BEGIN
            INSERT INTO EventSetupGroup(EventCode, GroupName, GroupLabel, GroupOrder, GroupPageMessage)
             VALUES (@eventCode, @groupName, @groupLabel, @grouporder, @groupText)
        END

GO